CREATE TABLE [dbo].[CountryRef]
(
[CountryCode] [nchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CountryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AddressFormatKey] [uniqueidentifier] NOT NULL,
[VATCountryCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IntraStateCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsActive] [bit] NOT NULL,
[IsHandModified] [bit] NOT NULL,
[MailGroup] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultShippingMethod] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SyncCountryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChapterGroupKey] [uniqueidentifier] NULL,
[ISO3DigitCode] [nchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[CountryKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_CountryRef_CountryKey] DEFAULT (newid())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [PK_CountryRef] PRIMARY KEY CLUSTERED ([CountryCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [AK_CountryRef_CountryKey] UNIQUE NONCLUSTERED ([CountryKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [AK_CountryRef_CountryName] UNIQUE NONCLUSTERED ([CountryName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CountryRef_ChapterGroupKey] ON [dbo].[CountryRef] ([ChapterGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CountryRef_DefaultShippingMethod] ON [dbo].[CountryRef] ([DefaultShippingMethod]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CountryRef_ISO3DigitCode] ON [dbo].[CountryRef] ([ISO3DigitCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CountryRef_UpdatedByUserKey] ON [dbo].[CountryRef] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [FK_CountryRef_AddressFormatRef] FOREIGN KEY ([AddressFormatKey]) REFERENCES [dbo].[AddressFormatRef] ([AddressFormatKey])
GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [FK_CountryRef_GroupMain_Chapter] FOREIGN KEY ([ChapterGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[CountryRef] ADD CONSTRAINT [FK_CountryRef_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO